package cn.edu.zjgsu.ito.model;

public class TeaScoreInputModel {
	public static TeaScoreInputModel dao=new TeaScoreInputModel();
	public String lookCourseSql="select * from teacher_timetable where tNo=?";
	public String lookTeaNameSql="select * from teacher_info where tNo=?";
	public String lookStudentsInfoSql="select * from student_timetable t,student_info i where t.passportNo=i.passportNo and t.uuid=? and i.studentStatus=?";
	public String insertTemplateSql="insert into template(type,fileName,newFileName,filePath,uploader,uploadTime) values(?,?,?,?,?,?)";
	public String insertUploadFileSql="insert into upload_file(type,fileName,newFileName,filePath,uploader,uploadTime) values(?,?,?,?,?,?)";
	public String insertGradeSql="insert into student_grade(sNo,majorName,grade,tName,courseName) values(?,?,?,?,?)";
	public String lookStudentSql="select * from student_grade where sNo=? and courseName=?";
	public String lookSaveStudentInfoSql="select * from student_grade s,student_info i where s.passportNo=i.passportNo and s.uuid=? and i.studentStatus=?";
	public String commitGradeSql="insert into student_grade(passportNo,majorNo,majorName,dailyGrade,experimentalGrade,finalGrade,otherGrade,grade,termValue,courseNo,courseName,tNo,gradeStatus,dailyPercent,experimentalPercent,finalPercent,otherPercent,uuid) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
	public String lookStudentGradeSql="select * from student_grade where passportNo=? and courseNo=? and termValue=? and uuid=?";
	public String updateCommitGradeSql="update student_grade set dailyGrade=?,experimentalGrade=?,finalGrade=?,otherGrade=?,grade=?,gradeStatus=?,dailyPercent=?,experimentalPercent=?,finalPercent=?,otherPercent=? where passportNo=? and courseNo=? and termValue=?";
	public String lookGradeStatusSql="select * from student_grade where uuid=?";
	public String lookteaTimetableSql="select * from teacher_timetable where uuid=?";
	public String findSNoByPassportNo="select * from student_info where passportNo=?";
	public String lookGradeInfoSql="select * from student_grade g,student_info i where g.passportNo=i.passportNo and g.uuid=? and i.studentStatus=?";
	public String lookcourseNameSql="select * from course where courseNo=?";
	public String lookRosterSql="select * from roster where uuid=?";
	public String lookCourseNoSql="select * from course_end where courseNo=?";



}
